EMT Practice Test

1. Question Content...

---

Question1: Which of the following techniques can you use to improve the performance of calculation views?Note: There are 2 correct answers to this question.

Question2: You create a table function to remove historic records, sum the current total weekly working hours for each employee, and update the personnel table with the results. The deployment of the table function fails.Which of the following could be a valid reason?

Question3: What are some best practices for writing SQLScript for use with calculation views?Note: There are 2 correct answers to this question.

Question4: How can you define a variable that presents its value help hierarchically?Note: There are 2 correct answers to this question.

Question5: You created a calculation view that combines two tables in a join node. To improve the runtime of your calculation view, you use a referential join to prune data sources.How do you check if pruning occurs?Note:
There are 2 correct answers to this question.

Question6: Why would you use the Transparent Filter property in a calculation view?

Question7: You import a project that includes an SAP HANA database (HDB) module to your workspace. You need to create a calculation view that uses data from a table located in an external schema within the same local database.Which of the following items do you need?Note: There are 2 correct answers to this question.

Question8: You want to create a star schema using a calculation view. The measures are based on columns from two transaction tables. Dimension calculation views provide the attributes.What is the correct approach?

Question9: In an XS Advanced project, what is the purpose of the .hdiconfig file?

Question10: Which tool generates and executes the SQL for a specific node of your calculation view?

Question11: In SAP Web IDE, you rename a dimension calculation view that is used by a cube calculation view. You do NOT use the option to rename the runtime view and adjust the reference. Afterward, you perform the following build operations:Build the dimension calculation view as a single object.Build the entire SAP HANA database module.What is the outcome of the build operations?

Question12: In a calculation view, why would you choose the DEPRECATED setting?Note: There are 2 correct answers to this question.

Question13: What are the limitations of using a full outer join in a star join node?Note: There are 2 correct answers to this question.

Question14: Why would you implement active / active read-enabled mode?

Question15: Your calculation view consumes one data source, which includes the following columns:
SALES_ORDER_ID, PRODUCT_ID, QUANTITY and PRICE.In the output, you want to see summarized data by PRODUCT_ID and a calculated column, PRODUCT_TOTAL, with the formula QUANTITY * PRICE.In which type of node do you define the calculation to display the correct result?

Question16: You set the Null Handling property for an attribute but do not set a default value.What is displayed when null values are found in a column of data type NVARCHAR?

Question17: You define a hierarchy in a calculation view. You want to expose the hierarchy to SQL Which of the following conditions must be met?Note: There are 2 correct answers to this question.

Question18: You have a cube calculation view that consumes a dimension view. You suspect some dimension columns have been renamed in the cube calculation view.Which function of SAP Web IDE for SAP HANA do you use to check where the output columns originate from?

Question19: What do you use in the definition of a dynamic SQL analytic privilege?

Question20: You created a table and inserted data in it using SQL statements inside the SAP HANA Deployment Infrastructure (HDI) container of your project. You add this table as a data source to a calculation view and try to build it.What do you observe in the SAP HANA database container?

Question21: Which of the following are usually not required In the data model of SAP S/4HANA?Note: There are 2 correct answers to this question.

Question22: You have defined a pruning configuration table in a calculation view.What are you attempting to prune from the query execution?

Question23: You deleted the design-time file of a calculation view in your HDB module.What is the recommended way to ensure that the corresponding runtime object is also removed from the database?

Question24: What are the consequences of NOT executing a delta merge?Note: There are 2 correct answers to this question.

Question25: What is generated when you deploy a CUBE calculation view design-time file?Note: There are 2 correct answers to this question.

Question26: Which of the following are warm data tier solutions?Note: There are 3 correct answers to this question.